UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1AWLG4dGFdqNvdB+dWnLeE2B1c4Ut1o8kF+rqtX/xmg='
WHERE
key_id = '7be43783e98b14ee71fa480c1ef2f0317dde091057fdb274fcdf32551114a347'
AND (
token = '1AWLG4dGFdqNvdB+dWnLeE2B1c4Ut1o8kF+rqtX/xmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)