UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXaRAz3Th1Y1U/0662+xWfgIhAtjhyHWGvjjcH5zF/c='
WHERE
key_id = 'a9e680fa7b0064e5d436a5be3fb8e197fa5e14e9232c9f2b20f044d8df9978fa'
AND (
token = 'mXaRAz3Th1Y1U/0662+xWfgIhAtjhyHWGvjjcH5zF/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)