UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '84sD3EVhCrYt5tU5YVYx8ICrwjemygpPJFWsg9U8zH0='
WHERE
key_id = 'd48f8f9b2fa1af4a9304e428ae01b977d2470f0d7f30db393b0fe307579fdeca'
AND (
token = '84sD3EVhCrYt5tU5YVYx8ICrwjemygpPJFWsg9U8zH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)