UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZ4BE1yiKgnTpP0pjNkzwG1LovyxAPPPxRqHP8OWcAw='
WHERE
key_id = '3e98a080e1de8f74bf1c322e781f8e3d996833348563b219024bb617963890b4'
AND (
token = 'cZ4BE1yiKgnTpP0pjNkzwG1LovyxAPPPxRqHP8OWcAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)