UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPYnIWv5D0x3yV+VMiAnXqVHpOluFQFjZilX5ELT/E8='
WHERE
key_id = 'f823ebf6cde12bbe6c54059e282513dc69a4058fd335a71b435dcee06a06aac2'
AND (
token = 'aPYnIWv5D0x3yV+VMiAnXqVHpOluFQFjZilX5ELT/E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)