UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OCy0RAWyo4jDwa7X1KfOcZdbbfwJT6aCGB2uL+4yk6U='
WHERE
key_id = 'e504a4fc901d126134c755aa8eebe726e65e4ef3a64e47652c3d54f019126907'
AND (
token = 'OCy0RAWyo4jDwa7X1KfOcZdbbfwJT6aCGB2uL+4yk6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)