UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9y3cDKBzP3qLdVLewa7XOSDC56n2BZeYRs9J/ZbIrcQ='
WHERE
key_id = 'a1ac5fb4ab4030896c54e8559c2e8b5e96544d49eda782ff9fc3c17706f9a754'
AND (
token = '9y3cDKBzP3qLdVLewa7XOSDC56n2BZeYRs9J/ZbIrcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)