UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hjdha0YltAEJa3MOqJhTuovN6kYiVbY/nF1dX9+h0B4='
WHERE
key_id = '644a24f3914f5ef5281e9ee3a5985106a0fd008d5813fe3b805ed92cdc97a4cc'
AND (
token = 'Hjdha0YltAEJa3MOqJhTuovN6kYiVbY/nF1dX9+h0B4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)