UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KP9d417HtR//WYEVgxR425MeoOD56szISr6C8mQ+1/k='
WHERE
key_id = 'c4cf73a08007c6beeb51d2f0d2799622ec86ba64e3a38b46f502bafa4fcaecaf'
AND (
token = 'KP9d417HtR//WYEVgxR425MeoOD56szISr6C8mQ+1/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)