UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eTxiAUamdpIrv5sJMhWYtMzsbaUT8kSjbycqM2K3bCo='
WHERE
key_id = 'c42db5eaad31a5f12b4d78c3124f98d4c6029399c511e1fc77b46f5cb1d29d7e'
AND (
token = 'eTxiAUamdpIrv5sJMhWYtMzsbaUT8kSjbycqM2K3bCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)