UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RzgCP9a51W6xBC/raoaxT0dCKhx1T7I7uu0OvVx0vh4='
WHERE
key_id = 'c5028e82ccca727cb206aae51684e019e8996edc1b01efc795e440366798eaaf'
AND (
token = 'RzgCP9a51W6xBC/raoaxT0dCKhx1T7I7uu0OvVx0vh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)