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