UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0b8M0diwqJd8npi5shW2Wnd5iKILpqvy3BZd3gHOkaA='
WHERE
key_id = 'b74683a2ce65773f79968d82a4e948f71cef8038c6bdc245eded545af6e0c876'
AND (
token = '0b8M0diwqJd8npi5shW2Wnd5iKILpqvy3BZd3gHOkaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)