UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v9edfRjRor+utL+R30ux26wTF05jfA18G6LLbJ10Eq4='
WHERE
key_id = 'ccb7df13dbd1d16255b0e5cc1b8d6dc3fb914040a668cf9cb0c6c01df1f3bc1d'
AND (
token = 'v9edfRjRor+utL+R30ux26wTF05jfA18G6LLbJ10Eq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)