UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PfhGT19i1G0g0CbsvPN+10bJFF4dmqzfYw5h0zSyDCY='
WHERE
key_id = 'c0f16623ac21ed65644bc5024ea31381191e1706f17bfb842d6b5639814035b9'
AND (
token = 'PfhGT19i1G0g0CbsvPN+10bJFF4dmqzfYw5h0zSyDCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)