UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jx6OSRNzuP47t6oBOYBX5qeK6jo5BAo3r4andG6bb/g='
WHERE
key_id = 'b337993b82ddebbceb8cac14a8d28622e878a6a175662d384c473e01ce08d801'
AND (
token = 'Jx6OSRNzuP47t6oBOYBX5qeK6jo5BAo3r4andG6bb/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)