UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KQW/9fok8oyQpTUseQkzL/Iy83b8sDeT+ibXEHjwl0='
WHERE
key_id = 'c170c7a52b4932871ac9d700c5933c76e074d432dea4a008cd66acd12adc9b5d'
AND (
token = '/KQW/9fok8oyQpTUseQkzL/Iy83b8sDeT+ibXEHjwl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)