UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uq5J8dS4Lp7nib4Npv4mXyYytwjW0pRjOeE3L8rhcdo='
WHERE
key_id = '789282fc0142010ed393c44222913ff4cc38943625f6ac7aedbdd80dbfb383fc'
AND (
token = 'uq5J8dS4Lp7nib4Npv4mXyYytwjW0pRjOeE3L8rhcdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)