UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4/SPvy7mDdW6aTtG3+w7+RlQXq4pdh+E9lc/tbjsx8='
WHERE
key_id = '45854bbe72d2e2fcd59442c52ef8b846d1677418cfb48db1f77e9741e6ee1065'
AND (
token = 'G4/SPvy7mDdW6aTtG3+w7+RlQXq4pdh+E9lc/tbjsx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)