UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcNghRPZ/eqmevY09v+c8OHsKbcmq71oBlvUp1/XNV8='
WHERE
key_id = '400135beeb2383dfd841b5786a70d1c178692f5913c9b9cabc42f2a94f26ab2a'
AND (
token = 'YcNghRPZ/eqmevY09v+c8OHsKbcmq71oBlvUp1/XNV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)