UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5z6q+dwcD688jbFNO8ktqNxOj5SEENHsCln4DaL+utk='
WHERE
key_id = 'c09a11d10bcbf9a7c12dfc99c85c79e6288de3d12beee54e80532e0fde7581c8'
AND (
token = '5z6q+dwcD688jbFNO8ktqNxOj5SEENHsCln4DaL+utk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)