UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rERAJCvf9NaXjHg9MljcV0cpxKvuzXFsRMn32IyDdbU='
WHERE
key_id = '3842e82bd708f437b6ceffdd1d4b7135c59a6610b21de39ac21810fe7f889a40'
AND (
token = 'rERAJCvf9NaXjHg9MljcV0cpxKvuzXFsRMn32IyDdbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)