UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGJdOc8AS0Vw8iRWaqs9ewMJNpyZgypkFrk2ILnaADM='
WHERE
key_id = 'b167d685445e5f55253ea8ea23c7ca8afc40c0814963d80f681e6767312a1b27'
AND (
token = 'zGJdOc8AS0Vw8iRWaqs9ewMJNpyZgypkFrk2ILnaADM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)