UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AgLCNCLiWlm5c2mWzvwcBRfX81MM/MFUSO7yPNYOQ/M='
WHERE
key_id = '7a811b6e2fa49cc6faa4e63a92c024122f1f7934081db2df62739f2e5dd0305d'
AND (
token = 'AgLCNCLiWlm5c2mWzvwcBRfX81MM/MFUSO7yPNYOQ/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)