UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRKrfXdofThcisPlKv2dVzPgSu/SDUpdi+3V/S/FnQ0='
WHERE
key_id = 'a8c7cf50840e7960b8a2887420233f00e470eeabfa2801dc3a1fff1442a2caa7'
AND (
token = 'xRKrfXdofThcisPlKv2dVzPgSu/SDUpdi+3V/S/FnQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)