UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rK63hlbq7UzZdfCoIRNKrS3k2ffcPJrrhkjXTqk9FDM='
WHERE
key_id = 'a6565c90595bbe36a97297540b9a03b581269e001e8f9e7b05e8c4c55183a207'
AND (
token = 'rK63hlbq7UzZdfCoIRNKrS3k2ffcPJrrhkjXTqk9FDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)