UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E5IG/PX2cxyWSXugM/kNsyWzn9TlupBKnwWlNLsT5rc='
WHERE
key_id = 'ffa75eba8f0561ef84ea4d3f354162e6c0f540c9fea0536a2f7a78d0b17a23e7'
AND (
token = 'E5IG/PX2cxyWSXugM/kNsyWzn9TlupBKnwWlNLsT5rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)