UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+HfeIW4Y3ZO7Cg5ORJoO67fZfZC95LFexSESd4W45U='
WHERE
key_id = '6688e05b9836e70fd9a605ba722ae9913ad4d8062a2874170035dfc7a69f49d6'
AND (
token = '6+HfeIW4Y3ZO7Cg5ORJoO67fZfZC95LFexSESd4W45U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)