UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acXyIeZHAwkkrXFsFa2lkUvbkTzHkdZX/SG0yS9EX60='
WHERE
key_id = '3807112f6fbe20399f450400bfa1f82ff392c82c1bbe5edc823d8212594849d2'
AND (
token = 'acXyIeZHAwkkrXFsFa2lkUvbkTzHkdZX/SG0yS9EX60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)