UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgOT9ndNC/UyFhyZaJji8RuK0MLgI5RoK2zlGcAE4d0='
WHERE
key_id = '6147fe02aff5766bedc951a96f03e51f77d4d40460f5e20a26afd8c831170df6'
AND (
token = 'pgOT9ndNC/UyFhyZaJji8RuK0MLgI5RoK2zlGcAE4d0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)