UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHbq7JDe6X86U3kEISP4lyw9qdunYjngL6DPxyCnvCs='
WHERE
key_id = '612a9d4eb24663fbe1686b99f4af329ff3c5b09dbe54f3e1ed3c644d35365f07'
AND (
token = 'ZHbq7JDe6X86U3kEISP4lyw9qdunYjngL6DPxyCnvCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)