UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLKZVyEYw33h0EbX6S/CuvRF/1OpSwoMw2S0cOE6xKU='
WHERE
key_id = '78cb9701341397dbf011502a336e0cf8892966cbc65fe062cf7ab7ab2ee776f8'
AND (
token = 'kLKZVyEYw33h0EbX6S/CuvRF/1OpSwoMw2S0cOE6xKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)