UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXLgj4PmI5j6qf4ZasQFdGErFib8HblZZ/zDtbvF5Ac='
WHERE
key_id = 'a54d54a33c7932bc511d89f8a2626f5d07ff835062efabe3f7cce3b7096ba1d7'
AND (
token = 'tXLgj4PmI5j6qf4ZasQFdGErFib8HblZZ/zDtbvF5Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)