UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wRiLpVMyHEgJmg/COImkbiXhFKNKpKE7v4sbHbNLm5s='
WHERE
key_id = '77b4e92d3678bfee6b83faa43364dc857a6b8277c9d20b9c829bac1fe6060285'
AND (
token = 'wRiLpVMyHEgJmg/COImkbiXhFKNKpKE7v4sbHbNLm5s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)