UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lN7euTUZmiKvBJ8VY/YL+YSD2JAEUGuib/F/2cykcRA='
WHERE
key_id = '8d3fd1944bf05bd1e9f516b52a962176d503cc2ccf49e9109a8cafc99aebf942'
AND (
token = 'lN7euTUZmiKvBJ8VY/YL+YSD2JAEUGuib/F/2cykcRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)